How to: Create a crosstab query using a wizard.
Solution:
Click the 'Queries' tab in the Database window, click 'New', select 'Crosstab Query Wizard' from the list box, click 'OK', and follow the instructions in the 'Crosstab Query Wizard' dialog boxes.
1) If the Database window is not active, activate the Database window.
2) Click the 'Queries' tab in the Database window.
Queries tab
3) Click 'New'. (The New Query dialog box appears.)
4) Select the 'Crosstab Query Wizard' from the list box.
Select wizard
NOTE: There are four query wizards available: 'Simple Query Wizard', 'Crosstab Query Wizard', 'Find Duplicates Query Wizard', and 'Find UnMatched Query Wizard'.
5) Click 'OK'. (The Crosstab Query Wizard dialog box appears.)
6) Select the table or query containing the fields to include in the crosstab query from the list box.
NOTE 1: To select from a list of tables only, select the 'Tables' radio button in the 'View' group. To select from a list of queries only, select the 'Queries' radio button. To select from a list of BOTH tables and queries, select the 'Both' radio button.
Select table or query
NOTE 2: To use fields from more than one table or query, first create a query containing all the fields, then select the query to use when creating the crosstab query.
7) Click 'Next'.
8) Select the desired field from the 'Available Fields' list box. (The selected field's values are used as row headings.)
Available fields
9) Click '>'. (The selected field appears in the Selected Fields list box.)
> button
10) Repeat steps 8) and 9) for each field to be used as a row heading in the crosstab query.
11) Click 'Next'.
12) Select the desired field to use its values as the column heading in the select query from the list box.
Select field
13) Click 'Next'.
14) Determine the desired calculations for each field:
a) Select a field from the 'Fields' list box.
Fields list box
b) Select the desired function to be performed on the selected field from the 'Functions' list box.
Functions list box
c) (Optional) Repeat steps 14)a) and 14)b) for each field in the 'Fields' list box.
15) (Optional) Select the 'Yes, include row sums' check box to summarize each row.
16) Click 'Next'.
17) Type a name for the crosstab query in the 'What do you want to name your query?' box.
Query name
18) Select the desired radio button for whether to run the query or to modify the query design.
Select radio button
19) Click 'Finish'. (The query appears in either Datasheet view or Design view, depending on the radio button selected in step 18).)
